package org.test

@Grab("hsqldb")

@Configuration
@EnableTransactionManagement
class Example implements CommandLineRunner {

    @Autowired
    JdbcTemplate jdbcTemplate

    @Transactional
    void run(String... args) {
        println "Foo count=" + jdbcTemplate.queryForObject("SELECT COUNT(*) from FOO", Integer)
    }
}

